package com.zjy.dao.user;

import com.zjy.pojo.Role;
import com.zjy.pojo.User;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

//面向接口
public interface UserDao {
    //得到要登录的用户
    public User getLoginUser(Connection connection,String UserCode) throws SQLException;
    //修改当前用户密码
    public int updatePwd(Connection connection,int id,String password) throws SQLException;
    //查询用户总数
    public int getUserCount(Connection connection,String username,int userRole) throws SQLException;
    //获取用户列表分页显示
    public List<User> getUserList(Connection connection,String username,int userRole,int currentPageNo,int pageSize) throws SQLException;
    //添加用户
    public int add(Connection connection,User user) throws SQLException;
    //删除用户
    public int delUser(Connection connection,Integer delId) throws SQLException;





}
